Roll Back Transaction
AutomatR.PostgreSQL.RollBackTransaction
The "Roll Back Transaction" activity in AutomatR for PostgreSQL databases allows you to roll back a transaction on a database. This activity is typically used in scenarios where a transaction needs to be canceled or reverted due to certain conditions or errors within the workflow.
Properties
| Name | Description |
|---|---|
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Roll Back Transaction" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Roll Back Transaction" activity onto the workflow.
- Ensure that this activity is placed within the scope of the "Start Transaction" activity to properly associate with an ongoing transaction.
- Optionally, configure the delay for the desired waiting time before rolling back the transaction.
- Execute the workflow to roll back the ongoing transaction in the PostgreSQL database.
Example: Consider an example where the "Roll Back Transaction" activity is used to cancel a transaction in case of an error:
Roll Back Transaction:
Delay: 2
In this example, the activity rolls back the ongoing transaction, helping to maintain data integrity and consistency in the PostgreSQL database.
Note: This activity should always be used within the scope of the "Start Transaction" activity to ensure proper association with a specific transaction in the workflow. Also, the delay is optional and can be configured based on specific requirements for handling transactions.